use IndustrialDashboard

CREATE TABLE [dbo].[catContinents](
	[ContinentID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	CONSTRAINT [PK_catContinents] PRIMARY KEY CLUSTERED 
	([ContinentID] ASC )WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
	) ON [PRIMARY]

	INSERT INTO [dbo].[catContinents] VALUES('America')
	INSERT INTO [dbo].[catContinents] VALUES('Europe')
	INSERT INTO [dbo].[catContinents] VALUES('Asia')
	INSERT INTO [dbo].[catContinents] VALUES('Africa')
	INSERT INTO [dbo].[catContinents] VALUES('Oceania')

GO
CREATE TABLE [dbo].[tblCountries](
	[CountryID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50)  NOT NULL,
	[Capital] [nvarchar](50)  NOT NULL,
	[Currency] [nvarchar](20)  NOT NULL,
	[Language] [nvarchar](50)  NOT NULL,
	[ContinentID] [int] NULL,
	 CONSTRAINT [PK_tblCountries] PRIMARY KEY CLUSTERED 
	([CountryID] ASC)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
	) ON [PRIMARY]

	INSERT INTO [dbo].[tblCountries] VALUES ('Japan','Tokyo','Yen','Japanese',3);
	INSERT INTO [dbo].[tblCountries] VALUES ('China','Beijing','Yuan','Chinese',3);
	INSERT INTO [dbo].[tblCountries] VALUES ('Germany','Berlin','Euro','German',2);
	INSERT INTO [dbo].[tblCountries] VALUES ('Italy','Rome','Euro','Italian',2);
	INSERT INTO [dbo].[tblCountries] VALUES ('Argentina','Buenos Aires','Peso','Spanish',1);
	INSERT INTO [dbo].[tblCountries] VALUES ('Australia','Sidney','Aud','English',5);
	INSERT INTO [dbo].[tblCountries] VALUES ('Brazil','Brasilia','Real','Portuguese',1);
	INSERT INTO [dbo].[tblCountries] VALUES ('France','Paris','Euro','French',2);
	INSERT INTO [dbo].[tblCountries] VALUES ('Russia','Moscow','RUB','Russian',3);
	INSERT INTO [dbo].[tblCountries] VALUES ('Egypt','Cairo','Libra','Arabic',4);
	INSERT INTO [dbo].[tblCountries] VALUES ('England','London','Euro','English',2);
	INSERT INTO [dbo].[tblCountries] VALUES ('Spain','Madrid','Euro','Spanish',2);
	INSERT INTO [dbo].[tblCountries] VALUES ('United States','Washington DC','Dolar','English',1);
GO
CREATE TABLE [dbo].[tblCities](
	[CityID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50)  NOT NULL,
	[CountryID] [int] NOT NULL,
	[Population] [int] NOT NULL,
	[Area] [int] NOT NULL,
	[Density] [int] NOT NULL,
	 CONSTRAINT [PK_tblCities] PRIMARY KEY CLUSTERED 
	([CityID] ASC)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
	) ON [PRIMARY]

	INSERT INTO dbo.tblCities VALUES('Los Angeles',13,3833995,1290,3156)
	INSERT INTO dbo.tblCities VALUES('Ashland, KY',13,833995,1290,3156)
	INSERT INTO dbo.tblCities VALUES('Seattle',13,3833995,1290,3156)
	INSERT INTO dbo.tblCities VALUES('San Antonio',13,3833995,1290,3156)
	INSERT INTO dbo.tblCities VALUES('Dallas',13,24326974,693622,3412)
	INSERT INTO dbo.tblCities VALUES('Tokyo',1,12790000,2187,5847)
	INSERT INTO dbo.tblCities VALUES('Kyoto',1,2790000,2187,5847)
	INSERT INTO dbo.tblCities VALUES('Beijing',2,17500000,16801,1044)
	INSERT INTO dbo.tblCities VALUES('Shangai',2,5500000,16801,1044)
	INSERT INTO dbo.tblCities VALUES('Berlin',3,3429870,891,3845)
	INSERT INTO dbo.tblCities VALUES('Frankfurt',3,3429870,891,3845)
	INSERT INTO dbo.tblCities VALUES('Munich',3,3429870,891,3845)
	INSERT INTO dbo.tblCities VALUES('Wurzburgo',3,135212,87,3845)
	INSERT INTO dbo.tblCities VALUES('Rome',4,273638,1285,2115)
	INSERT INTO dbo.tblCities VALUES('Milan',4,273638,1285,2115)
	INSERT INTO dbo.tblCities VALUES('Napoles',4,273638,1285,2115)
	INSERT INTO dbo.tblCities VALUES('Firenze',4,962447,117,8263)
	INSERT INTO dbo.tblCities VALUES('Ottawa',22,159704,2778,27812)
	INSERT INTO dbo.tblCities VALUES('Toronto',22,8159704,2778,27812)
	INSERT INTO dbo.tblCities VALUES('Vancouver',22,859704,2778,27812)
	INSERT INTO dbo.tblCities VALUES('Sidney',6,4336374,12406,2058)
	INSERT INTO dbo.tblCities VALUES('Buenos Aires',5,2995805,202,14825)
	INSERT INTO dbo.tblCities VALUES('Cordoba',5,1309536,576,2273)
	INSERT INTO dbo.tblCities VALUES('Bahia Blanca',5,1309536,576,2273)
	INSERT INTO dbo.tblCities VALUES('Rosario',5,1309536,576,2273)
	INSERT INTO dbo.tblCities VALUES('Brasilia',7,2606885,5802,4232)
	INSERT INTO dbo.tblCities VALUES('Sao Paulo',7,2606885,5802,4232)
	INSERT INTO dbo.tblCities VALUES('Rio de Janeiro',7,2606885,5802,4232)
	INSERT INTO dbo.tblCities VALUES('Bahia',7,2606885,5802,4232)
	INSERT INTO dbo.tblCities VALUES('Paris',8,2193030,105,20886)
	INSERT INTO dbo.tblCities VALUES('Marsella',8,2193030,105,20886)
	INSERT INTO dbo.tblCities VALUES('Moscow',9,10562099,1081,9722)
	INSERT INTO dbo.tblCities VALUES('St Petersburg',9,10562099,1081,9722)
	INSERT INTO dbo.tblCities VALUES('Cairo',10,17734334,1424501,35047)
	INSERT INTO dbo.tblCities VALUES('London',11,755690,1706,4000)
	INSERT INTO dbo.tblCities VALUES('Manchester',11,755690,1706,4000)
	INSERT INTO dbo.tblCities VALUES('Liverpool',11,755690,1706,4000)
	INSERT INTO dbo.tblCities VALUES('Madrid',12,3255944,605,5374)
	INSERT INTO dbo.tblCities VALUES('Zaragoza',12,1255944,605,5374)
	INSERT INTO dbo.tblCities VALUES('Barcelona',12,4255944,605,537)


GO
CREATE TABLE [dbo].[tblGantt1](
	[Station] [nvarchar](20) COLLATE Latin1_General_CI_AI NOT NULL,
	[Batch] [nvarchar](10) COLLATE Latin1_General_CI_AI NOT NULL,
	[number] [int] NOT NULL,
	[initialQuality] [nvarchar](10) COLLATE Latin1_General_CI_AI NULL,
	[Quality] [nvarchar](10) COLLATE Latin1_General_CI_AI NULL,
	[StartTime] [datetime] NULL,
	[EndTime] [datetime] NULL,
	[Weight] [nvarchar](255) COLLATE Latin1_General_CI_AI NULL,
 CONSTRAINT [PK_tblGantt1] PRIMARY KEY CLUSTERED 
(
	[Station] ASC,
	[Batch] ASC,
	[number] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

go
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 1' ,'12H0' , 1  ,'1100' ,'1100' ,'Apr  3 2010 12:09PM' ,'Apr  3 2010  1:43PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 1' ,'12H3' , 1  ,'775' ,'775' ,'Apr  3 2010  5:42PM' ,'Apr  3 2010  7:05PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 1' ,'12H5' , 1  ,'775' ,'775' ,'Apr  3 2010  7:06PM' ,'Apr  3 2010  8:23PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 1' ,'12H7' , 1  ,'775' ,'775' ,'Apr  3 2010  8:25PM' ,'Apr  3 2010  9:56PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 1' ,'12K4' , 1  ,'715' ,'715' ,'Apr  4 2010 11:19AM' ,'Apr  4 2010 12:56PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 1' ,'12K6' , 1  ,'715' ,'715' ,'Apr  4 2010 12:57PM' ,'Apr  4 2010  2:19PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 1' ,'12K8' , 1  ,'575' ,'575' ,'Apr  4 2010  3:01PM' ,'Apr  4 2010  4:19PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 1' ,'12K9' , 1  ,'575' ,'575' ,'Apr  4 2010  4:21PM' ,'Apr  4 2010  5:32PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 1' ,'12N1' , 1  ,'1530' ,'1530' ,'Apr  5 2010 11:23AM' ,'Apr  5 2010  1:22PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 1' ,'12N3' , 1  ,'1530' ,'1530' ,'Apr  5 2010  1:23PM' ,'Apr  5 2010  3:16PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12E7' , 1  ,'505' ,'505' ,'Apr  2 2010 11:46PM' ,'Apr  3 2010 12:53AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12E8' , 1  ,'515' ,'515' ,'Apr  3 2010 12:54AM' ,'Apr  3 2010  2:00AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12E9' , 1  ,'520' ,'520' ,'Apr  3 2010  2:02AM' ,'Apr  3 2010  2:52AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12F0' , 1  ,'1350' ,'1350' ,'Apr  3 2010  3:50AM' ,'Apr  3 2010  4:48AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12F1' , 1  ,'1350' ,'1350' ,'Apr  3 2010  4:50AM' ,'Apr  3 2010  5:34AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12F2' , 1  ,'1350' ,'1350' ,'Apr  3 2010  5:35AM' ,'Apr  3 2010  6:19AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12F3' , 1  ,'1350' ,'1350' ,'Apr  3 2010  6:21AM' ,'Apr  3 2010  7:01AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12F4' , 1  ,'1350' ,'1350' ,'Apr  3 2010  7:02AM' ,'Apr  3 2010  7:50AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12F5' , 1  ,'1350' ,'1350' ,'Apr  3 2010  7:52AM' ,'Apr  3 2010  8:44AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12F6' , 1  ,'1350' ,'1350' ,'Apr  3 2010  8:45AM' ,'Apr  3 2010  9:32AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12F7' , 1  ,'1350' ,'1350' ,'Apr  3 2010  9:34AM' ,'Apr  3 2010 10:25AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12F8' , 1  ,'1350' ,'1350' ,'Apr  3 2010 10:26AM' ,'Apr  3 2010 11:37AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12F9' , 1  ,'1350' ,'1350' ,'Apr  3 2010 11:39AM' ,'Apr  3 2010 12:28PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12H1' , 1  ,'525' ,'525' ,'Apr  3 2010  2:19PM' ,'Apr  3 2010  3:34PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12H2' , 1  ,'525' ,'525' ,'Apr  3 2010  3:35PM' ,'Apr  3 2010  4:59PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12H4' , 1  ,'505' ,'505' ,'Apr  3 2010  5:01PM' ,'Apr  3 2010  6:18PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12H8' , 1  ,'100' ,'100' ,'Apr  3 2010 11:11PM' ,'Apr  4 2010 12:01AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12H9' , 1  ,'100' ,'100' ,'Apr  4 2010 12:03AM' ,'Apr  4 2010 12:52AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12J0' , 1  ,'100' ,'100' ,'Apr  3 2010 10:03PM' ,'Apr  3 2010 11:09PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12J1' , 1  ,'100' ,'100' ,'Apr  4 2010 12:54AM' ,'Apr  4 2010  1:44AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12J2' , 1  ,'600' ,'600' ,'Apr  4 2010  1:45AM' ,'Apr  4 2010  2:36AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12J3' , 1  ,'600' ,'600' ,'Apr  4 2010  2:38AM' ,'Apr  4 2010  3:27AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12J4' , 1  ,'600' ,'600' ,'Apr  4 2010  3:29AM' ,'Apr  4 2010  4:22AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12J5' , 1  ,'600' ,'600' ,'Apr  4 2010  4:24AM' ,'Apr  4 2010  5:16AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12J6' , 1  ,'600' ,'600' ,'Apr  4 2010  5:59AM' ,'Apr  4 2010  6:58AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12J7' , 1  ,'600' ,'600' ,'Apr  4 2010  7:00AM' ,'Apr  4 2010  7:50AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12J8' , 1  ,'600' ,'600' ,'Apr  4 2010  7:52AM' ,'Apr  4 2010  8:37AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12J9' , 1  ,'600' ,'600' ,'Apr  4 2010  8:39AM' ,'Apr  4 2010  9:32AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12K0' , 1  ,'600' ,'600' ,'Apr  4 2010  9:33AM' ,'Apr  4 2010 10:22AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12K1' , 1  ,'750' ,'750' ,'Apr  4 2010 10:24AM' ,'Apr  4 2010 11:14AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12K2' , 1  ,'750' ,'750' ,'Apr  4 2010 11:16AM' ,'Apr  4 2010 12:04PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12K3' , 1  ,'750' ,'750' ,'Apr  4 2010 12:05PM' ,'Apr  4 2010 12:53PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12K5' , 1  ,'750' ,'750' ,'Apr  4 2010 12:54PM' ,'Apr  4 2010  1:45PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12K7' , 1  ,'750' ,'750' ,'Apr  4 2010  1:47PM' ,'Apr  4 2010  2:35PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12L0' , 1  ,'750' ,'750' ,'Apr  4 2010  3:41PM' ,'Apr  4 2010  4:44PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12L1' , 1  ,'750' ,'750' ,'Apr  4 2010  4:45PM' ,'Apr  4 2010  5:34PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12L2' , 1  ,'750' ,'750' ,'Apr  4 2010  5:36PM' ,'Apr  4 2010  6:28PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12L3' , 1  ,'600' ,'600' ,'Apr  4 2010  6:30PM' ,'Apr  4 2010  7:24PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12L4' , 1  ,'600' ,'600' ,'Apr  4 2010  7:26PM' ,'Apr  4 2010  8:15PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12L5' , 1  ,'600' ,'600' ,'Apr  4 2010  8:17PM' ,'Apr  4 2010  9:05PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12L6' , 1  ,'600' ,'600' ,'Apr  4 2010  9:06PM' ,'Apr  4 2010  9:56PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12L7' , 1  ,'600' ,'600' ,'Apr  4 2010 10:50PM' ,'Apr  4 2010 11:40PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12L8' , 1  ,'600' ,'600' ,'Apr  4 2010  9:57PM' ,'Apr  4 2010 10:48PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12L9' , 1  ,'250' ,'250' ,'Apr  5 2010  1:45AM' ,'Apr  5 2010  2:40AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12M0' , 1  ,'250' ,'250' ,'Apr  5 2010 12:37AM' ,'Apr  5 2010  1:41AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12M1' , 1  ,'750' ,'750' ,'Apr  5 2010  2:42AM' ,'Apr  5 2010  3:23AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12M2' , 1  ,'750' ,'750' ,'Apr  5 2010  3:25AM' ,'Apr  5 2010  4:11AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12M3' , 1  ,'750' ,'750' ,'Apr  5 2010  4:12AM' ,'Apr  5 2010  4:57AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12M4' , 1  ,'600' ,'600' ,'Apr  5 2010  4:59AM' ,'Apr  5 2010  5:46AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12M5' , 1  ,'600' ,'600' ,'Apr  5 2010  5:48AM' ,'Apr  5 2010  6:35AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12M6' , 1  ,'600' ,'600' ,'Apr  5 2010  6:36AM' ,'Apr  5 2010  7:16AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12M7' , 1  ,'600' ,'600' ,'Apr  5 2010  7:18AM' ,'Apr  5 2010  8:04AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12M8' , 1  ,'600' ,'600' ,'Apr  5 2010  8:05AM' ,'Apr  5 2010  8:49AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12M9' , 1  ,'600' ,'600' ,'Apr  5 2010 10:34AM' ,'Apr  5 2010 12:00PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12N0' , 1  ,'600' ,'600' ,'Apr  5 2010 12:02PM' ,'Apr  5 2010  1:18PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12N2' , 1  ,'600' ,'600' ,'Apr  5 2010  1:20PM' ,'Apr  5 2010  2:20PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12N4' , 1  ,'3000' ,'3000' ,'Apr  5 2010  3:00PM' ,'Apr  5 2010  4:14PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12N5' , 1  ,'3005' ,'3005' ,'Apr  5 2010  4:16PM' ,'Apr  5 2010  5:23PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12N6' , 1  ,'3005' ,'3005' ,'Apr  5 2010  5:25PM' ,'Apr  5 2010  6:28PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12N7' , 1  ,'3005' ,'3005' ,'Apr  5 2010  6:30PM' ,'Apr  5 2010  7:22PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12N8' , 1  ,'3005' ,'3005' ,'Apr  5 2010  7:24PM' ,'Apr  5 2010  8:21PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12N9' , 1  ,'3005' ,'3005' ,'Apr  5 2010  8:22PM' ,'Apr  5 2010  9:21PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12P0' , 1  ,'3005' ,'3005' ,'Apr  5 2010  9:22PM' ,'Apr  5 2010 10:15PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'Caster 2' ,'12P1' , 1  ,'3005' ,'3005' ,'Apr  5 2010 10:17PM' ,'Apr  5 2010 11:07PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12F0' , 1  ,'1350' ,'1350' ,'Apr  2 2010 11:22PM' ,'Apr  3 2010 12:30AM' ,'55600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12F2' , 1  ,'1350' ,'1350' ,'Apr  3 2010 12:40AM' ,'Apr  3 2010  1:49AM' ,'59600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12F4' , 1  ,'1350' ,'1350' ,'Apr  3 2010  2:00AM' ,'Apr  3 2010  3:06AM' ,'54000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12F6' , 1  ,'1350' ,'1350' ,'Apr  3 2010  3:16AM' ,'Apr  3 2010  4:41AM' ,'59600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12F8' , 1  ,'1350' ,'1350' ,'Apr  3 2010  4:52AM' ,'Apr  3 2010  6:02AM' ,'48000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12H0' , 1  ,'1100' ,'1100' ,'Apr  3 2010  6:12AM' ,'Apr  3 2010  7:25AM' ,'52800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12H2' , 1  ,'525' ,'525' ,'Apr  3 2010  7:36AM' ,'Apr  3 2010  8:47AM' ,'59200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12H4' , 1  ,'505' ,'505' ,'Apr  3 2010  8:55AM' ,'Apr  3 2010 10:48AM' ,'55600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12H6' , 1  ,'515' ,'515' ,'Apr  3 2010 10:57AM' ,'Apr  3 2010 12:10PM' ,'54800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12H8' , 1  ,'100' ,'100' ,'Apr  3 2010 12:24PM' ,'Apr  3 2010  1:56PM' ,'56400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12H9' , 1  ,'100' ,'100' ,'Apr  3 2010  2:09PM' ,'Apr  3 2010  3:44PM' ,'56800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12J0' , 1  ,'100' ,'100' ,'Apr  3 2010  3:54PM' ,'Apr  3 2010  5:08PM' ,'56800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12J2' , 1  ,'600' ,'600' ,'Apr  3 2010  5:24PM' ,'Apr  3 2010  6:48PM' ,'59200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12J4' , 1  ,'600' ,'600' ,'Apr  3 2010  7:02PM' ,'Apr  3 2010  8:22PM' ,'60000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12J6' , 1  ,'600' ,'600' ,'Apr  3 2010  8:34PM' ,'Apr  3 2010 10:49PM' ,'56400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12J8' , 1  ,'600' ,'600' ,'Apr  3 2010 11:04PM' ,'Apr  4 2010  1:15AM' ,'57200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12K0' , 1  ,'510' ,'600' ,'Apr  4 2010  1:27AM' ,'Apr  4 2010  3:22AM' ,'56000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12K2' , 1  ,'750' ,'750' ,'Apr  4 2010  3:37AM' ,'Apr  4 2010  5:12AM' ,'54800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12K4' , 1  ,'715' ,'715' ,'Apr  4 2010  5:30AM' ,'Apr  4 2010  7:06AM' ,'56400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12K6' , 1  ,'715' ,'715' ,'Apr  4 2010  7:15AM' ,'Apr  4 2010  8:34AM' ,'58800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12K8' , 1  ,'575' ,'575' ,'Apr  4 2010  8:44AM' ,'Apr  4 2010  9:52AM' ,'56800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12L0' , 1  ,'750' ,'750' ,'Apr  4 2010  9:59AM' ,'Apr  4 2010 11:07AM' ,'52000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12L2' , 1  ,'750' ,'750' ,'Apr  4 2010 11:19AM' ,'Apr  4 2010 12:45PM' ,'57600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12L4' , 1  ,'600' ,'600' ,'Apr  4 2010 12:53PM' ,'Apr  4 2010  2:35PM' ,'55200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12L6' , 1  ,'600' ,'600' ,'Apr  4 2010  2:44PM' ,'Apr  4 2010  4:19PM' ,'54800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12L8' , 1  ,'600' ,'600' ,'Apr  4 2010  4:26PM' ,'Apr  4 2010  5:33PM' ,'51600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12M0' , 1  ,'250' ,'250' ,'Apr  4 2010  5:40PM' ,'Apr  4 2010  6:48PM' ,'59200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12M2' , 1  ,'750' ,'750' ,'Apr  4 2010  6:57PM' ,'Apr  4 2010  8:08PM' ,'55200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12M4' , 1  ,'600' ,'600' ,'Apr  4 2010  8:30PM' ,'Apr  4 2010  9:48PM' ,'58000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12M6' , 1  ,'600' ,'600' ,'Apr  4 2010  9:56PM' ,'Apr  5 2010 12:30AM' ,'54800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12M8' , 1  ,'600' ,'600' ,'Apr  5 2010 12:39AM' ,'Apr  5 2010  2:12AM' ,'57200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12N0' , 1  ,'600' ,'600' ,'Apr  5 2010  2:20AM' ,'Apr  5 2010  3:36AM' ,'64400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12N2' , 1  ,'600' ,'600' ,'Apr  5 2010  3:54AM' ,'Apr  5 2010  5:40AM' ,'58400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12N9' , 1  ,'3005' ,'3005' ,'Apr  5 2010  1:33PM' ,'Apr  5 2010  2:51PM' ,'57200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12P1' , 1  ,'3005' ,'3005' ,'Apr  5 2010  3:49PM' ,'Apr  5 2010  6:52PM' ,'49200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12P3' , 1  ,'750' ,'750' ,'Apr  5 2010  7:46PM' ,'Apr  5 2010  9:15PM' ,'58400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #1         ' ,'12P5' , 1  ,'750' ,'750' ,'Apr  5 2010 10:18PM' ,'Apr  5 2010 11:57PM' ,'56800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12F1' , 1  ,'1350' ,'1350' ,'Apr  3 2010 12:06AM' ,'Apr  3 2010  1:26AM' ,'51600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12F3' , 1  ,'1350' ,'1350' ,'Apr  3 2010  1:31AM' ,'Apr  3 2010  2:54AM' ,'61600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12F5' , 1  ,'1350' ,'1350' ,'Apr  3 2010  3:04AM' ,'Apr  3 2010  4:15AM' ,'54800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12F7' , 1  ,'1350' ,'1350' ,'Apr  3 2010  4:27AM' ,'Apr  3 2010  5:41AM' ,'54400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12F9' , 1  ,'1350' ,'1350' ,'Apr  3 2010  6:01AM' ,'Apr  3 2010  7:08AM' ,'52800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12H1' , 1  ,'525' ,'525' ,'Apr  3 2010  7:17AM' ,'Apr  3 2010  8:25AM' ,'54800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12H3' , 1  ,'775' ,'775' ,'Apr  3 2010  8:33AM' ,'Apr  3 2010  9:44AM' ,'50800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12H5' , 1  ,'775' ,'775' ,'Apr  3 2010  9:59AM' ,'Apr  3 2010  3:09PM' ,'57200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12H7' , 1  ,'775' ,'775' ,'Apr  3 2010  3:19PM' ,'Apr  3 2010  4:37PM' ,'56800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12J1' , 1  ,'100' ,'100' ,'Apr  3 2010  4:57PM' ,'Apr  3 2010  6:08PM' ,'56800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12J3' , 1  ,'600' ,'600' ,'Apr  3 2010  6:17PM' ,'Apr  3 2010  8:01PM' ,'58800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12J5' , 1  ,'600' ,'600' ,'Apr  3 2010  8:20PM' ,'Apr  3 2010  9:30PM' ,'60800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12J7' , 1  ,'600' ,'600' ,'Apr  3 2010  9:38PM' ,'Apr  3 2010 11:54PM' ,'59600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12J9' , 1  ,'600' ,'600' ,'Apr  4 2010 12:14AM' ,'Apr  4 2010  2:47AM' ,'59200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12K1' , 1  ,'750' ,'750' ,'Apr  4 2010  2:56AM' ,'Apr  4 2010  4:07AM' ,'54800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12K3' , 1  ,'750' ,'750' ,'Apr  4 2010  4:14AM' ,'Apr  4 2010  5:53AM' ,'58400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12K5' , 1  ,'750' ,'750' ,'Apr  4 2010  6:04AM' ,'Apr  4 2010  7:27AM' ,'54400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12K7' , 1  ,'750' ,'750' ,'Apr  4 2010  7:43AM' ,'Apr  4 2010  8:50AM' ,'56400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12K9' , 1  ,'575' ,'575' ,'Apr  4 2010  9:00AM' ,'Apr  4 2010 10:05AM' ,'53600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12L1' , 1  ,'750' ,'750' ,'Apr  4 2010 10:12AM' ,'Apr  4 2010 11:50AM' ,'52800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12L3' , 1  ,'600' ,'600' ,'Apr  4 2010 11:58AM' ,'Apr  4 2010  1:18PM' ,'52000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12L5' , 1  ,'600' ,'600' ,'Apr  4 2010  1:23PM' ,'Apr  4 2010  2:44PM' ,'54000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12L7' , 1  ,'600' ,'600' ,'Apr  4 2010  2:52PM' ,'Apr  4 2010  4:56PM' ,'54000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12L9' , 1  ,'250' ,'250' ,'Apr  4 2010  5:06PM' ,'Apr  4 2010  6:20PM' ,'54400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12M1' , 1  ,'750' ,'750' ,'Apr  4 2010  6:30PM' ,'Apr  4 2010  7:41PM' ,'59200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12M3' , 1  ,'750' ,'750' ,'Apr  4 2010  7:52PM' ,'Apr  4 2010  9:31PM' ,'57200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12M5' , 1  ,'600' ,'600' ,'Apr  4 2010  9:40PM' ,'Apr  4 2010 11:10PM' ,'54400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12M7' , 1  ,'600' ,'600' ,'Apr  4 2010 11:20PM' ,'Apr  5 2010 12:37AM' ,'60000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12M9' , 1  ,'600' ,'600' ,'Apr  5 2010  1:02AM' ,'Apr  5 2010  2:27AM' ,'56400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12N1' , 1  ,'1530' ,'1530' ,'Apr  5 2010  2:36AM' ,'Apr  5 2010  5:26AM' ,'56800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12N3' , 1  ,'1530' ,'1530' ,'Apr  5 2010  5:37AM' ,'Apr  5 2010  7:06AM' ,'56000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12N4' , 1  ,'3000' ,'3000' ,'Apr  5 2010  7:17AM' ,'Apr  5 2010  8:26AM' ,'52800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12N5' , 1  ,'3005' ,'3005' ,'Apr  5 2010  8:37AM' ,'Apr  5 2010 10:01AM' ,'50000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12N6' , 1  ,'3005' ,'3005' ,'Apr  5 2010 10:04AM' ,'Apr  5 2010 11:13AM' ,'55200' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12N7' , 1  ,'3005' ,'3005' ,'Apr  5 2010 11:26AM' ,'Apr  5 2010 12:33PM' ,'54800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12N8' , 1  ,'3005' ,'3005' ,'Apr  5 2010 12:38PM' ,'Apr  5 2010  1:34PM' ,'54000' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12P0' , 1  ,'3005' ,'3005' ,'Apr  5 2010  1:45PM' ,'Apr  5 2010  3:52PM' ,'50400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12P2' , 1  ,'750' ,'750' ,'Apr  5 2010  5:25PM' ,'Apr  5 2010  6:34PM' ,'55600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12P4' , 1  ,'750' ,'750' ,'Apr  5 2010  6:38PM' ,'Apr  5 2010  7:51PM' ,'56400' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12P6' , 1  ,'750' ,'750' ,'Apr  5 2010  9:51PM' ,'Apr  5 2010 10:58PM' ,'54800' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'BO #2         ' ,'12P7' , 1  ,'600' ,'600' ,'Apr  5 2010 11:30PM' ,'Apr  6 2010 12:42AM' ,'55600' ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12E8' , 1  ,'515' ,'515' ,'Apr  3 2010 12:45AM' ,'Apr  3 2010 12:47AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12E9' , 1  ,'520' ,'520' ,'Apr  3 2010  1:32AM' ,'Apr  3 2010  1:41AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12F0' , 1  ,'1350' ,'1350' ,'Apr  3 2010  2:46AM' ,'Apr  3 2010  3:28AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12F1' , 1  ,'1350' ,'1350' ,'Apr  3 2010  4:02AM' ,'Apr  3 2010  4:40AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12F2' , 1  ,'1350' ,'1350' ,'Apr  3 2010  4:51AM' ,'Apr  3 2010  5:27AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12F3' , 1  ,'1350' ,'1350' ,'Apr  3 2010  5:35AM' ,'Apr  3 2010  6:07AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12F4' , 1  ,'1350' ,'1350' ,'Apr  3 2010  6:34AM' ,'Apr  3 2010  6:47AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12F5' , 1  ,'1350' ,'1350' ,'Apr  3 2010  7:06AM' ,'Apr  3 2010  7:37AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12F6' , 1  ,'1350' ,'1350' ,'Apr  3 2010  7:56AM' ,'Apr  3 2010  8:26AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12F7' , 1  ,'1350' ,'1350' ,'Apr  3 2010  8:43AM' ,'Apr  3 2010  9:15AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12F8' , 1  ,'1350' ,'1350' ,'Apr  3 2010  9:38AM' ,'Apr  3 2010 10:10AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H0' , 1  ,'1100' ,'1100' ,'Apr  3 2010 10:54AM' ,'Apr  3 2010 11:58AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H1' , 1  ,'525' ,'525' ,'Apr  3 2010  1:12PM' ,'Apr  3 2010  2:05PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H2' , 1  ,'525' ,'525' ,'Apr  3 2010  2:40PM' ,'Apr  3 2010  3:10PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H3' , 1  ,'775' ,'775' ,'Apr  3 2010  4:08PM' ,'Apr  3 2010  5:26PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H5' , 1  ,'775' ,'775' ,'Apr  3 2010  6:25PM' ,'Apr  3 2010  6:53PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H5' , 2  ,'775' ,'775' ,'Apr  3 2010  6:54PM' ,'Apr  3 2010  6:58PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H6' , 1  ,'515' ,'515' ,'Apr  3 2010  6:06PM' ,'Apr  3 2010  6:23PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H7' , 1  ,'775' ,'775' ,'Apr  3 2010  7:23PM' ,'Apr  3 2010  8:13PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H8' , 1  ,'100' ,'100' ,'Apr  3 2010  8:25PM' ,'Apr  3 2010  8:42PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H8' , 2  ,'100' ,'100' ,'Apr  3 2010 10:08PM' ,'Apr  3 2010 10:54PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12H9' , 1  ,'100' ,'100' ,'Apr  3 2010 11:27PM' ,'Apr  3 2010 11:42PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12J0' , 1  ,'100' ,'100' ,'Apr  3 2010  9:06PM' ,'Apr  3 2010  9:50PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12J1' , 1  ,'100' ,'100' ,'Apr  3 2010 11:58PM' ,'Apr  4 2010 12:38AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12J2' , 1  ,'600' ,'600' ,'Apr  4 2010 12:54AM' ,'Apr  4 2010  1:23AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12J3' , 1  ,'600' ,'600' ,'Apr  4 2010  1:42AM' ,'Apr  4 2010  2:28AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12J5' , 1  ,'600' ,'600' ,'Apr  4 2010  3:36AM' ,'Apr  4 2010  4:08AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12J6' , 1  ,'600' ,'600' ,'Apr  4 2010  5:00AM' ,'Apr  4 2010  5:39AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12J7' , 1  ,'600' ,'600' ,'Apr  4 2010  6:17AM' ,'Apr  4 2010  6:39AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12J8' , 1  ,'600' ,'600' ,'Apr  4 2010  7:04AM' ,'Apr  4 2010  7:37AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12J9' , 1  ,'600' ,'600' ,'Apr  4 2010  7:51AM' ,'Apr  4 2010  8:26AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12K0' , 1  ,'600' ,'600' ,'Apr  4 2010  9:04AM' ,'Apr  4 2010  9:21AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12K2' , 1  ,'750' ,'750' ,'Apr  4 2010 10:29AM' ,'Apr  4 2010 11:02AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12K3' , 1  ,'750' ,'750' ,'Apr  4 2010 11:24AM' ,'Apr  4 2010 11:56AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12K5' , 1  ,'750' ,'750' ,'Apr  4 2010 12:37PM' ,'Apr  4 2010 12:41PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12K7' , 1  ,'750' ,'750' ,'Apr  4 2010  1:11PM' ,'Apr  4 2010  1:38PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12K8' , 1  ,'575' ,'575' ,'Apr  4 2010  1:59PM' ,'Apr  4 2010  2:49PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12K9' , 1  ,'575' ,'575' ,'Apr  4 2010  3:19PM' ,'Apr  4 2010  4:08PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12L2' , 1  ,'750' ,'750' ,'Apr  4 2010  4:50PM' ,'Apr  4 2010  5:21PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12L3' , 1  ,'600' ,'600' ,'Apr  4 2010  5:42PM' ,'Apr  4 2010  6:19PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12L5' , 1  ,'600' ,'600' ,'Apr  4 2010  7:26PM' ,'Apr  4 2010  8:04PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12L6' , 1  ,'600' ,'600' ,'Apr  4 2010  8:23PM' ,'Apr  4 2010  8:52PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12L7' , 1  ,'600' ,'600' ,'Apr  4 2010  9:59PM' ,'Apr  4 2010 10:35PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12L8' , 1  ,'600' ,'600' ,'Apr  4 2010  9:15PM' ,'Apr  4 2010  9:43PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12L9' , 1  ,'250' ,'250' ,'Apr  5 2010  1:02AM' ,'Apr  5 2010  1:21AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12M0' , 1  ,'250' ,'250' ,'Apr  4 2010 11:26PM' ,'Apr  5 2010 12:25AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12M2' , 1  ,'750' ,'750' ,'Apr  5 2010  2:06AM' ,'Apr  5 2010  3:15AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12M3' , 1  ,'750' ,'750' ,'Apr  5 2010  3:27AM' ,'Apr  5 2010  3:52AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12M4' , 1  ,'600' ,'600' ,'Apr  5 2010  4:06AM' ,'Apr  5 2010  4:45AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12M5' , 1  ,'600' ,'600' ,'Apr  5 2010  4:57AM' ,'Apr  5 2010  5:27AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12M6' , 1  ,'600' ,'600' ,'Apr  5 2010  6:03AM' ,'Apr  5 2010  6:22AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12M7' , 1  ,'600' ,'600' ,'Apr  5 2010  6:35AM' ,'Apr  5 2010  7:06AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12M9' , 1  ,'600' ,'600' ,'Apr  5 2010  7:18AM' ,'Apr  5 2010  7:50AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12M9' , 2  ,'600' ,'600' ,'Apr  5 2010  8:20AM' ,'Apr  5 2010 10:22AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12N0' , 1  ,'600' ,'600' ,'Apr  5 2010 11:07AM' ,'Apr  5 2010 11:53AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12N2' , 1  ,'600' ,'600' ,'Apr  5 2010 12:04PM' ,'Apr  5 2010 12:51PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12N3' , 1  ,'1530' ,'1530' ,'Apr  5 2010 12:52PM' ,'Apr  5 2010  1:13PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12N4' , 1  ,'3000' ,'3000' ,'Apr  5 2010  2:04PM' ,'Apr  5 2010  2:47PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12N5' , 1  ,'3005' ,'3005' ,'Apr  5 2010  3:16PM' ,'Apr  5 2010  3:49PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12N6' , 1  ,'3005' ,'3005' ,'Apr  5 2010  4:13PM' ,'Apr  5 2010  5:03PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12N7' , 1  ,'3005' ,'3005' ,'Apr  5 2010  5:33PM' ,'Apr  5 2010  6:21PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12N8' , 1  ,'3005' ,'3005' ,'Apr  5 2010  6:34PM' ,'Apr  5 2010  7:13PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12N9' , 1  ,'3005' ,'3005' ,'Apr  5 2010  7:28PM' ,'Apr  5 2010  8:08PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12P0' , 1  ,'3005' ,'3005' ,'Apr  5 2010  8:26PM' ,'Apr  5 2010  9:11PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12P1' , 1  ,'3005' ,'3005' ,'Apr  5 2010  9:27PM' ,'Apr  5 2010  9:59PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #1' ,'12P2' , 1  ,'750' ,'750' ,'Apr  5 2010 11:24PM' ,'Apr  6 2010 12:03AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12E9' , 1  ,'520' ,'520' ,'Apr  3 2010 12:01AM' ,'Apr  3 2010  1:17AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12F1' , 1  ,'1350' ,'1350' ,'Apr  3 2010  1:57AM' ,'Apr  3 2010  3:25AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12F3' , 1  ,'1350' ,'1350' ,'Apr  3 2010  3:43AM' ,'Apr  3 2010  5:19AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12F5' , 1  ,'1350' ,'1350' ,'Apr  3 2010  5:24AM' ,'Apr  3 2010  6:47AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12F7' , 1  ,'1350' ,'1350' ,'Apr  3 2010  6:50AM' ,'Apr  3 2010  8:11AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12F9' , 2  ,'1350' ,'1350' ,'Apr  3 2010 10:01AM' ,'Apr  3 2010 11:06AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12H0' , 1  ,'1100' ,'1100' ,'Apr  3 2010  8:14AM' ,'Apr  3 2010  9:59AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12H1' , 1  ,'525' ,'525' ,'Apr  3 2010 11:10AM' ,'Apr  3 2010 12:41PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12H2' , 1  ,'500' ,'525' ,'Apr  3 2010 12:45PM' ,'Apr  3 2010  2:10PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12H4' , 1  ,'505' ,'505' ,'Apr  3 2010  2:13PM' ,'Apr  3 2010  3:38PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12H6' , 1  ,'515' ,'515' ,'Apr  3 2010  3:39PM' ,'Apr  3 2010  4:59PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12H8' , 1  ,'100' ,'100' ,'Apr  3 2010  5:34PM' ,'Apr  3 2010  6:52PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12J0' , 1  ,'100' ,'100' ,'Apr  3 2010  7:26PM' ,'Apr  3 2010  8:29PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12J2' , 1  ,'600' ,'600' ,'Apr  3 2010  8:33PM' ,'Apr  3 2010  9:44PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12J4' , 1  ,'600' ,'600' ,'Apr  3 2010 11:20PM' ,'Apr  4 2010  1:03AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12J5' , 1  ,'600' ,'600' ,'Apr  4 2010  1:13AM' ,'Apr  4 2010  2:31AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12J6' , 1  ,'600' ,'600' ,'Apr  4 2010  2:40AM' ,'Apr  4 2010  3:54AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12J8' , 1  ,'600' ,'600' ,'Apr  4 2010  4:00AM' ,'Apr  4 2010  5:13AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12K0' , 1  ,'600' ,'600' ,'Apr  4 2010  5:29AM' ,'Apr  4 2010  6:56AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12K2' , 1  ,'750' ,'750' ,'Apr  4 2010  6:59AM' ,'Apr  4 2010  8:34AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12K4' , 1  ,'715' ,'715' ,'Apr  4 2010  8:38AM' ,'Apr  4 2010 10:03AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12K6' , 1  ,'715' ,'715' ,'Apr  4 2010 10:06AM' ,'Apr  4 2010 11:49AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12K8' , 1  ,'575' ,'575' ,'Apr  4 2010 11:54AM' ,'Apr  4 2010  1:29PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12K9' , 1  ,'575' ,'575' ,'Apr  4 2010  1:32PM' ,'Apr  4 2010  2:38PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12L2' , 1  ,'750' ,'750' ,'Apr  4 2010  2:41PM' ,'Apr  4 2010  3:55PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12L4' , 1  ,'600' ,'600' ,'Apr  4 2010  3:58PM' ,'Apr  4 2010  5:05PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12L5' , 1  ,'600' ,'600' ,'Apr  4 2010  5:09PM' ,'Apr  4 2010  6:30PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12L7' , 1  ,'600' ,'600' ,'Apr  4 2010  6:34PM' ,'Apr  4 2010  8:12PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12L9' , 1  ,'250' ,'250' ,'Apr  4 2010  8:22PM' ,'Apr  4 2010  9:40PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12M3' , 1  ,'750' ,'750' ,'Apr  4 2010 11:42PM' ,'Apr  5 2010  1:28AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12M5' , 1  ,'600' ,'600' ,'Apr  5 2010  1:35AM' ,'Apr  5 2010  3:18AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12M7' , 1  ,'600' ,'600' ,'Apr  5 2010  3:53AM' ,'Apr  5 2010  5:29AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12M9' , 1  ,'600' ,'600' ,'Apr  5 2010  5:34AM' ,'Apr  5 2010  7:01AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12N1' , 1  ,'1530' ,'1530' ,'Apr  5 2010  7:06AM' ,'Apr  5 2010  9:05AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12N3' , 1  ,'1500' ,'1530' ,'Apr  5 2010  9:10AM' ,'Apr  5 2010 11:07AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12N5' , 1  ,'3005' ,'3005' ,'Apr  5 2010 11:57AM' ,'Apr  5 2010  2:01PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12P4' , 1  ,'750' ,'750' ,'Apr  5 2010  9:37PM' ,'Apr  5 2010 11:02PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #1         ' ,'12P6' , 1  ,'750' ,'750' ,'Apr  5 2010 11:30PM' ,'Apr  6 2010 12:46AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12E8' , 1  ,'515' ,'515' ,'Apr  2 2010 11:04PM' ,'Apr  3 2010 12:39AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12F0' , 1  ,'1350' ,'1350' ,'Apr  3 2010  1:11AM' ,'Apr  3 2010  2:34AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12F2' , 1  ,'1350' ,'1350' ,'Apr  3 2010  2:45AM' ,'Apr  3 2010  4:07AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12F4' , 1  ,'1350' ,'1350' ,'Apr  3 2010  4:11AM' ,'Apr  3 2010  5:33AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12F6' , 1  ,'1350' ,'1350' ,'Apr  3 2010  5:40AM' ,'Apr  3 2010  7:12AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12F8' , 1  ,'1350' ,'1350' ,'Apr  3 2010  7:15AM' ,'Apr  3 2010  8:50AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12F9' , 1  ,'1350' ,'1350' ,'Apr  3 2010  8:56AM' ,'Apr  3 2010  9:47AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12H3' , 1  ,'775' ,'775' ,'Apr  3 2010  2:14PM' ,'Apr  3 2010  3:48PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12H5' , 1  ,'775' ,'775' ,'Apr  3 2010  3:57PM' ,'Apr  3 2010  5:10PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12H7' , 1  ,'775' ,'775' ,'Apr  3 2010  5:20PM' ,'Apr  3 2010  6:55PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12H9' , 1  ,'100' ,'100' ,'Apr  3 2010  7:01PM' ,'Apr  3 2010  8:06PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12J1' , 1  ,'100' ,'100' ,'Apr  3 2010  8:15PM' ,'Apr  3 2010  9:55PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12J3' , 1  ,'600' ,'600' ,'Apr  3 2010 10:00PM' ,'Apr  3 2010 11:46PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12J7' , 1  ,'600' ,'600' ,'Apr  4 2010  3:00AM' ,'Apr  4 2010  4:10AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12J9' , 1  ,'600' ,'600' ,'Apr  4 2010  4:35AM' ,'Apr  4 2010  5:41AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12K1' , 1  ,'750' ,'750' ,'Apr  4 2010  5:59AM' ,'Apr  4 2010  7:26AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12K3' , 1  ,'750' ,'750' ,'Apr  4 2010  7:29AM' ,'Apr  4 2010  9:10AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12K5' , 1  ,'750' ,'750' ,'Apr  4 2010  9:18AM' ,'Apr  4 2010 10:57AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12K7' , 1  ,'750' ,'750' ,'Apr  4 2010 11:00AM' ,'Apr  4 2010 12:26PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12L0' , 1  ,'750' ,'750' ,'Apr  4 2010 12:34PM' ,'Apr  4 2010  1:57PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12L1' , 1  ,'750' ,'750' ,'Apr  4 2010  2:01PM' ,'Apr  4 2010  3:30PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12L3' , 1  ,'600' ,'600' ,'Apr  4 2010  3:48PM' ,'Apr  4 2010  5:15PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12L6' , 1  ,'600' ,'600' ,'Apr  4 2010  5:19PM' ,'Apr  4 2010  6:44PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12L8' , 1  ,'600' ,'600' ,'Apr  4 2010  6:47PM' ,'Apr  4 2010  8:26PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12M0' , 1  ,'250' ,'250' ,'Apr  4 2010  8:34PM' ,'Apr  4 2010  9:54PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12M1' , 1  ,'750' ,'750' ,'Apr  4 2010 10:03PM' ,'Apr  4 2010 11:28PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12M2' , 1  ,'500' ,'750' ,'Apr  4 2010 11:32PM' ,'Apr  5 2010 12:58AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12M4' , 1  ,'600' ,'600' ,'Apr  5 2010  1:14AM' ,'Apr  5 2010  2:24AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12M6' , 1  ,'600' ,'600' ,'Apr  5 2010  2:33AM' ,'Apr  5 2010  3:56AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12M8' , 1  ,'600' ,'600' ,'Apr  5 2010  4:19AM' ,'Apr  5 2010  5:41AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12N0' , 1  ,'600' ,'600' ,'Apr  5 2010  5:46AM' ,'Apr  5 2010  7:29AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12N2' , 1  ,'600' ,'600' ,'Apr  5 2010  7:38AM' ,'Apr  5 2010  9:25AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12N4' , 1  ,'3000' ,'3000' ,'Apr  5 2010  9:48AM' ,'Apr  5 2010 12:31PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12N6' , 1  ,'3005' ,'3005' ,'Apr  5 2010  2:02PM' ,'Apr  5 2010  3:23PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12N7' , 1  ,'3005' ,'3005' ,'Apr  5 2010  3:25PM' ,'Apr  5 2010  4:35PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12N8' , 1  ,'3005' ,'3005' ,'Apr  5 2010  4:38PM' ,'Apr  5 2010  5:42PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12N9' , 1  ,'3005' ,'3005' ,'Apr  5 2010  5:45PM' ,'Apr  5 2010  6:58PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12P0' , 1  ,'3005' ,'3005' ,'Apr  5 2010  7:04PM' ,'Apr  5 2010  8:00PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12P1' , 1  ,'3005' ,'3005' ,'Apr  5 2010  8:06PM' ,'Apr  5 2010  8:58PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12P2' , 1  ,'750' ,'750' ,'Apr  5 2010  9:17PM' ,'Apr  5 2010 10:36PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'RH #2         ' ,'12P3' , 1  ,'750' ,'750' ,'Apr  5 2010 10:41PM' ,'Apr  6 2010 12:18AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12F4' , 1  ,'1350' ,'1350' ,'Apr  3 2010  6:18AM' ,'Apr  3 2010  6:27AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12F9' , 1  ,'1350' ,'1350' ,'Apr  3 2010 11:19AM' ,'Apr  3 2010 11:30AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12H4' , 1  ,'505' ,'505' ,'Apr  3 2010  4:05PM' ,'Apr  3 2010  4:45PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12H6' , 1  ,'515' ,'515' ,'Apr  3 2010  5:11PM' ,'Apr  3 2010  5:46PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12H8' , 1  ,'100' ,'100' ,'Apr  3 2010  7:49PM' ,'Apr  3 2010  8:11PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12H9' , 1  ,'100' ,'100' ,'Apr  3 2010 11:06PM' ,'Apr  3 2010 11:18PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12J4' , 1  ,'600' ,'600' ,'Apr  4 2010  2:37AM' ,'Apr  4 2010  3:12AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12J7' , 1  ,'600' ,'600' ,'Apr  4 2010  6:00AM' ,'Apr  4 2010  6:10AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12K0' , 1  ,'600' ,'600' ,'Apr  4 2010  8:29AM' ,'Apr  4 2010  8:57AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12K1' , 1  ,'750' ,'750' ,'Apr  4 2010  9:26AM' ,'Apr  4 2010 10:16AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12K4' , 1  ,'715' ,'715' ,'Apr  4 2010 10:41AM' ,'Apr  4 2010 11:01AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12K6' , 1  ,'715' ,'715' ,'Apr  4 2010 11:55AM' ,'Apr  4 2010 12:43PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12L0' , 1  ,'750' ,'750' ,'Apr  4 2010  2:26PM' ,'Apr  4 2010  3:26PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12L1' , 1  ,'1610' ,'750' ,'Apr  4 2010  4:00PM' ,'Apr  4 2010  4:36PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12L4' , 1  ,'600' ,'600' ,'Apr  4 2010  6:40PM' ,'Apr  4 2010  7:17PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12L7' , 1  ,'600' ,'600' ,'Apr  4 2010  9:02PM' ,'Apr  4 2010  9:13PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12L9' , 1  ,'250' ,'250' ,'Apr  5 2010 12:36AM' ,'Apr  5 2010 12:45AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12M1' , 1  ,'750' ,'750' ,'Apr  5 2010  1:32AM' ,'Apr  5 2010  2:16AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12M6' , 1  ,'600' ,'600' ,'Apr  5 2010  5:41AM' ,'Apr  5 2010  5:59AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12M8' , 1  ,'600' ,'600' ,'Apr  5 2010  7:18AM' ,'Apr  5 2010  7:50AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12N1' , 1  ,'1530' ,'1530' ,'Apr  5 2010  9:37AM' ,'Apr  5 2010 11:09AM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12N2' , 1  ,'600' ,'600' ,'Apr  5 2010  1:02PM' ,'Apr  5 2010  1:08PM' , NULL  ) 
INSERT INTO tblGantt1 (Station ,Batch ,number ,initialQuality ,Quality ,StartTime ,EndTime ,Weight ) VALUES ( 'LF #2' ,'12N3' , 1  ,'1530' ,'1530' ,'Apr  5 2010 11:31AM' ,'Apr  5 2010 12:37PM' , NULL  ) 


GO

CREATE TABLE [dbo].[catSidebarMenu](
	[ID] [int] NOT NULL,
	[Parent] [int] NULL,
	[AppCode] [nvarchar](15) COLLATE Latin1_General_CI_AI NULL,
	[Name] [nvarchar](50) COLLATE Latin1_General_CI_AI NULL,
	[URL] [nvarchar](max) COLLATE Latin1_General_CI_AI NULL,
	[Target] [nchar](50) COLLATE Latin1_General_CI_AI NULL,
	[Image] [nvarchar](max) COLLATE Latin1_General_CI_AI NULL,
	[SortOrder] [int] NULL,
	[Enabled] [bit] NOT NULL,
	[Visible] [bit] NOT NULL
) ON [PRIMARY]

GO
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  1  , NULL  , NULL  ,'Samples 1' , NULL  ,'_self                                             ' ,'Icon2' , 1  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  2  , 1  ,'App1.1' ,'Samples 1.1' , NULL  ,'_self                                             ' , NULL  , 1  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  3  , 1  ,'App1.2' ,'Samples 1.2' , NULL  ,'_new                                              ' , NULL  , 2  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  4  , NULL  , NULL  ,'Samples 2' , NULL  ,'_new                                              ' ,'Icon4' , 2  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  5  , 4  ,'App2.1' ,'Samples 2.1' , NULL  ,'_new                                              ' , NULL  , 1  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  6  , 4  ,'App2.2' ,'Samples 2.2' , NULL  ,'_new                                              ' , NULL  , 2  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  7  , 6  ,'App2.2.1' ,'Samples 2.2.1' , NULL  ,'_new                                              ' , NULL  , 1  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  8  , 6  ,'App2.2.2' ,'Samples 2.2.2' , NULL  ,'_new                                              ' , NULL  , 2  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  9  , 4  ,'App2.3' ,'Samples 2.3' , NULL  ,'_self                                             ' , NULL  , 3  , 1  , 0  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  10  , 4  ,'App2.4' ,'Samples 2.4' , NULL  ,'_self                                             ' , NULL  , 4  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  11  , NULL  , NULL  ,'Samples 3' , NULL  ,'_self                                             ' ,'Icon5' , 3  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  12  , 11  ,'App3.1' ,'Samples 3.1' , NULL  ,'_self                                             ' , NULL  , 1  , 1  , 1  ) 
INSERT INTO catSidebarMenu (ID ,Parent ,AppCode ,Name ,URL ,Target ,Image ,SortOrder ,Enabled ,Visible ) VALUES (  13  , 11  ,'App3.2' ,'Samples 3.2' , NULL  ,'_self                                             ' , NULL  , 2  , 1  , 1  ) 
GO
CREATE PROCEDURE [dbo].[getDropDownPickerData]
AS
BEGIN
	/* Table of contents */	
		SELECT  [PickerID] = 1, [Title] = 'Continent :', [Type]='Int', [Name] = 'ContinentID',	[ParentID] = 0, [Attrib] =  ''
	UNION SELECT		 2,	'Country :',	[Type]='Int',		'CountryID',				1,	''

	/* Continents */	
	SELECT  null, 'All Continents',0,null,[Order] =''
	UNION
	SELECT
	ID = ContinentID
	,Title = [Name]
	,[Default] = CASE WHEN ContinentID=1 THEN 1 ELSE 0 END
	,ParentValue = 0
	,[Order] = [Name]
	FROM dbo.catContinents
	ORDER BY [Order]

	/* Countries */	
	SELECT  null, 'All Countries',0,null,[Order] =''
	UNION
	SELECT
	ID = CountryID
	,Title = [Name]
	,[Default] = CASE WHEN CountryID=1 THEN 1 ELSE 0 END
	,ParentValue = ContinentID  
	,[Order] = [Name]
	FROM dbo.tblCountries
	ORDER BY [Order]
END

GO

CREATE PROCEDURE [dbo].[getCountryData]
@CountryID int = 1
AS
BEGIN
	SELECT
	[Name]
	,Population
	,Area
	,Density
	FROM dbo.tblCities AS c
	WHERE c.CountryID = @CountryID
END

GO
CREATE PROCEDURE [dbo].[getBatchDataIG]
@startDate datetime = '2010-4-4',
@endDate datetime = '2010-4-5'
AS
BEGIN
	SELECT TOP 40
	[Station!he!rs] = [Station],  /* he -> header style, rs-> row span */
	[Batch@Number] = Batch,   /* the @ sign is used to group and colspan titles */
	[Batch@Visit] = number,
	[Quality@Initial] = initialQuality,
	[Quality@Final] = Quality,
	[Time@Start] = CONVERT(CHAR(8), startTime , 108),
	[Time@End] = CONVERT(CHAR(8), [endTime] , 108),
	[Time@Elapsed] = CONVERT(CHAR(8), [endTime]-startTime , 108),
	[Weight] = [Weight]
	FROM dbo.tblGantt1 
	where startTime between @startdate and @enddate 
    order by station, StartTime

/*  calculate errors and warnings on certain fields */
	SELECT
	[Batch@Number] = case when number>1 then 'warning!reprocess' else NULL end,
	[Batch@Visit] = case when number>1 then 'warning!reprocess' else NULL end,
	[Quality@Final] = case when initialQuality<>Quality  then 'problem!Quality change' else NULL end,
	[Weight] = case when Weight>56000 then 'error!Weigh Error (>56K)' else NULL end

/*  must use exactly same number of rows and row order 
    repeat the from/where/order clauses or use a temp table */
	FROM dbo.tblGantt1 
	where startTime between @startdate and @enddate 
	order by Station, startTime

END

GO

CREATE PROCEDURE [dbo].[getBatchDataIGCalendar]
@Date datetime = '2010-4-4'
AS
BEGIN
	SELECT TOP 40
	[Station!he!rs] = [Station],  /* he -> header style, rs-> row span */
	[Batch@Number] = Batch,   /* the @ sign is used to group and colspan titles */
	[Batch@Visit] = number,
	[Quality@Initial] = initialQuality,
	[Quality@Final] = Quality,
	[Time@Start] = CONVERT(CHAR(8), startTime , 108),
	[Time@End] = CONVERT(CHAR(8), [endTime] , 108),
	[Time@Elapsed] = CONVERT(CHAR(8), [endTime]-startTime , 108),
	[Weight] = [Weight]
	FROM dbo.tblGantt1 
	WHERE CONVERT(NVARCHAR(12),StartTime,101) = CONVERT(NVARCHAR(12), @Date, 101) 
    ORDER BY station, StartTime

/*  calculate errors and warnings on certain fields */
	SELECT
	[Batch@Number] = case when number>1 then 'warning!reprocess' else NULL end,
	[Batch@Visit] = case when number>1 then 'warning!reprocess' else NULL end,
	[Quality@Final] = case when initialQuality<>Quality  then 'problem!Quality change' else NULL end,
	[Weight] = case when Weight>56000 then 'error!Weigh Error (>56K)' else NULL end

/*  must use exactly same number of rows and row order 
    repeat the from/where/order clauses or use a temp table */
	FROM dbo.tblGantt1 
	where CONVERT(NVARCHAR(12),StartTime,101) = CONVERT(NVARCHAR(12), @Date, 101) 
	ORDER BY Station, startTime

END

GO

CREATE PROCEDURE [dbo].[getCitiesList]
@CountryID int = 0
AS
BEGIN
	SELECT
	[Name]
	,Population
	,Area
	,Density
	FROM dbo.tblCities AS c
	WHERE c.CountryID = @CountryID
END

GO
CREATE PROCEDURE [dbo].[getChartData]
@Date datetime 
AS
BEGIN
	SELECT
		[Quality] = cast(g.[Quality] as int)*100.0
		,[Weight] = g.[Weight]
		,[Date] = CONVERT(NVARCHAR(5),g.StartTime,8)
	FROM 
		dbo.tblGantt1 g
	WHERE 
		CONVERT(NVARCHAR(12),g.StartTime,101) = CONVERT(NVARCHAR(12), @Date, 101)
		AND g.Station like 'BO%'	
END

GO

CREATE PROCEDURE [dbo].[spGetSidebarMenuData] 
AS
BEGIN
SET NOCOUNT ON;

select * into #t1 from dbo.catSidebarMenu where Parent is NULL and Enabled=1 order by [SortOrder] -- Depth=0 or NULL
select * into #t2 from dbo.catSidebarMenu where Parent in (select ID from #t1) and Enabled=1 order by [SortOrder] -- Depth=1
select * into #t3 from dbo.catSidebarMenu where Parent in (select ID from #t2) and Enabled=1 order by [SortOrder] -- Depth=2
select * into #t4 from dbo.catSidebarMenu where Parent in (select ID from #t3) and Enabled=1 order by [SortOrder] -- Depth=3

select * from #t1
select * from #t2
select * from #t3
select * from #t4
END



